/*
# Rouleur Log - A log for cyclists.
# Copyright (C) 2006  Edward Copony (ecopony@gmail.com)
# 
# This program is free software; you can redistribute it and/or
# modify it under the terms of the GNU General Public License
# as published by the Free Software Foundation; either version 2
# of the License, or (at your option) any later version.
# 
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
# 
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
*/
package com.blazingredfireball.rouleurlog.business
{
	import mx.rpc.IResponder;
	import flash.data.SQLStatement;
	import flash.data.SQLResult;
	import com.blazingredfireball.rouleurlog.model.RouleurlogModelLocator;
	import mx.controls.AdvancedDataGrid;
	import mx.controls.Alert;
	
	public class BikeDelegate
	{
	  private var model:RouleurlogModelLocator = RouleurlogModelLocator.getInstance();
		private var responder : IResponder;
		
		public function BikeDelegate(responder : IResponder)
		{
			this.responder = responder;
		}
		
		public function getBikes() : void
		{
      var sql:String = "SELECT * FROM bikes ORDER BY name";
      model.doSql(sql, responder);
		}
		
		public function createBike(bike:Object) : void
		{
      var sql:String = "INSERT INTO bikes (name, description, created_on, updated_on) VALUES (\"" + 
        bike.name + "\", \"" + 
        bike.description + "\", " +
        bike.created_on.getTime() + ", " +
        bike.updated_on.getTime() + ")";
      model.doSql(sql, responder);      
		}
		
		public function deleteBike(id : int) : void
		{			
      var sql:String = "DELETE FROM bikes WHERE id = " + id
      model.doSql(sql, responder);
		}
		
		public function updateBike(id : int, bike : Object) : void
		{			
			var sql:String = "UPDATE bikes SET name = \"" + bike.name + 
			"\", description = \"" + bike.description  + "\", updated_on = \"" + 
			  new Date().getTime() + "\" WHERE id = " + id;
      model.doSql(sql, responder);
		}
	}
}